Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the intercept when you want to determine the value of the dependent variable when the independent variable is 0 (zero). For example, you can use the INTERCEPT function to predict a metal's electrical resistance at 0°C when your data points were taken at room temperature and higher.
Syntax
INTERCEPT(known_y's,known_x's)
Known_y's is the dependent set of observations or data.
Known_x's is the independent set of observations or data.
Remarks
where the slope is calculated as:
Example
The example may be easier to understand if you copy it to a blank spreadsheet.
Selecting an example from Help
Known y | Known x |
---|---|
2 | 6 |
3 | 5 |
9 | 11 |
1 | 7 |
8 | 5 |
Formula | Description (Result) |
=INTERCEPT(A2:A6, B2:B6) | Point at which a line will intersect the y-axis by using the x-values and y-values above (0.0483871) |